﻿using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using CE.Database;

/// <summary>
/// Summary description for InsurerDB
/// </summary>
/// 
namespace CE.Provider
{
    public class InsurerDB
    {
        public InsurerDB()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        public DataTable GetPreInsurer(Int32 ServiceType, Int32 CompanyType)
        {
            MyDatabase _Db = new MyDatabase();
            string _spName = "sprocPreInsurerSelectItemList";
            CompanyLogo _result = null;
            DataTable _dt;
            SortedList _sPara = new SortedList();

            _sPara.Add("@ServiceType", ServiceType);
            _sPara.Add("@CompanyType", CompanyType);

            _dt = _Db.GetDataTableBySP(_spName, _sPara);

            return _dt;
        }

    }
}